E-mail Lookup System Index for Level 1
emlookup
A
1
upper( contact1.email )
17:37
First Name, Last Name
uk00000400
upper( trim(contact1.firstname) + contact1.lastname )
Last Name
uk00000401
upper( contact1.lastname )
Home Phone
uk00000402
upper( contact1.phone )
Hire Date
uk00000403
contact1.hiredate
Employee Number
uk00000404
upper( contact1.employeeno )
Review Date
uk00000405
2
contact2.reviewdate
Effective Date
uk00000406
contact2.effectdate